Multidatabase global query optimization
نویسندگان
چکیده
Data requests ro mulriaiztabase (MDBSs) are posed through non-procedural languages such as SQL and for a global data request optimization must be performed to achieve good system performance. However, the issues are ofren complicated in multidatabases, due to addirional issues arising because of the autonomy and heterogeneity restrictions of the independent local DBMSs. The data translation problem between various local systems can be observed at the schema level and at the instance level. We have identified the need for a domain translation table in mulridatabase query processing and discuss methods of implementing it. Some observations about multidatabase inter-site joins are made and four methods by which mulridatabase global queries can be processed are introduced and analytically compared.
منابع مشابه
Query Decomposition, Optimization and Processing in Multidatabase Systems
One way of achieving interoperability among heterogeneous, federated DBMSs is through a multidatabase system that supports a single common data model and a single global query language on top of different types of existing systems. The global schema of a multidatabase system is the result of a schema integration of the schemas exported from the underlying databases, i.e., local databases. A glo...
متن کاملGlobal Query Optimization Based on Multistate Cost Models for a Dynamic Multidatabase System
Global query optimization in a multidatabase system (MDBS) is a challenging issue since some local optimization information such as local cost models may not be available at the global level due to local autonomy. It becomes even more difficult when dynamic environmental factors are taken into consideration. In our previous work, a qualitative approach was suggested to build so-called multistat...
متن کاملA New Framework For Query Optimization In Multidatabase System Environment
Due to the changing business environment, the need arises to integrate the pre-existing database system in federated way. A great effort had been done to enhance the performance of the Multidatabase management system (MDBMS). The most critical issue considered in this area is the query optimization that can be considered as the backbone of any successful database. Reviewing the most recent rela...
متن کاملDeveloping Cost Models with Qualitative Variables for Dynamic Multidatabase Environments
A major challenge for global query optimization in a multidatabase system (MDBS) is lack of local cost information at the global level due to local autonomy. A number of methods to derive local cost models have been suggested recently. However, these methods are only suitable for a static multidatabase environment. In this paper, we propose a new multi-states query sampling method to develop lo...
متن کاملApproximate Processing for Medical Record Linking and Multidatabase Analysis
In this article we investigate how approximate query processing (AQP) can be used in medical multidatabase systems. We identify two areas where this estimation technique will be of use. First, approximate query processing can be used to preprocess medical record linking in the multidatabase. Second, approximate answers can be given for aggregate queries. In the case of multidatabase systems use...
متن کامل